/*
 * Copyright (c) 2015 www.smarthome.com All rights reserved.
 * 本软件源代码版权归----所有,未经许可不得任意复制与传播.
 */
package com.smarthome.base.dao;

import java.util.List;

import com.smarthome.domain.bean.ShPropertyFee;
import com.smarthome.base.dao.base.BaseDao;

/**
 * ShPropertyFeeDao 接口
 * 
 * @author KongXiangyu
 * @since 2015-09-07
 */
public interface ShPropertyFeeDao extends BaseDao<ShPropertyFee, Long> {
	// 自定义扩展
	List<ShPropertyFee> selectEntryListByDoorId(ShPropertyFee fee);
	
	/**
	 * 根据门牌号和年份查询物业费 注：年份格式为2015，setMonth放入查询对象中
	 * 
	 * @param fee
	 * @return
	 */
	List<ShPropertyFee> getByDoorIdAndYear(ShPropertyFee fee);
	
	List<ShPropertyFee> getByDoorIdAndMonth(ShPropertyFee fee);
	
	/**
	 * 
	* @Title: queryFeesGroupByDoorCount 
	* @Description: 根据条件查询以门牌分组的物业费之和的数目 
	* @param queryPropertyFee
	* @return
	* Long
	* @throws 
	* @author cyj
	 */
	Long queryFeesGroupByDoorCount(ShPropertyFee queryPropertyFee);
	
	/**
	 * 
	* @Title: queryFeesGroupByDoor 
	* @Description: 根据条件查询以门牌分组的物业费之和
	* @param queryPropertyFee
	* @return
	* List<ShPropertyFee>
	* @throws 
	* @author cyj
	 */
	List<ShPropertyFee> queryFeesGroupByDoor(ShPropertyFee queryPropertyFee);
	
	/**
	 * 
	* queryAmountSumByResidence
	* @Title: queryAmountSumByResidence
	* @Description: 根据条件查询小区物业费汇总
	* @param queryPropertyFee
	* @return
	* Long
	* @throws
	* @author cyj
	* @date 2015年11月18日 下午12:03:59
	 */
	Long queryAmountSumByResidence(ShPropertyFee queryPropertyFee);
}